two days suming using vlookup

[avk]

I have using excel 2003.
I have three sheet : accounts / staff / service_fsr

In service_fsr we have data sheet.
In staff sheet service person fill travel expence bill
In accounts sheet : calculate using of above two sheet base on fsr no.

I have facing problem to calculate : if service person fill one fsr no i.e. "333333" of two days works than in accounts sheet calculate of two days amount.

We have attach file for your ready reference.

[avk]

bump. If any other solution confirm.

[DonkeyOte]

Why are you using VLOOKUP as opposed to SUMIF ? e.g.:

Please Login or Register  to view this content.