Vlookup
 

Help! I am comparing Invoices numbers on two large spreadsheets and have
this formula. The Problem I have is that it is not showing me the correct
results. I've done a quick manual search and found the invoices are on both
sheets.

=VLOOKUP(E3,'[Metrossl billing.xls]Sheet1'!$A:$C,1,FALSE)

What can I do?

Thank you, Siobhan

Vlookup
 

In A:C column which either B or C column results can be retrieved
using the vlookup,
but in your formula u trying the 1 column (col A) results. Check out
again change the value 1 to 2 or 3 as required.




On Jun 5, 9:15*pm, Siobhan Plover
wrote:
Help! *I am comparing Invoices numbers on two large spreadsheets and have
this formula. *The Problem I have is that it is not showing me the correct
results. *I've done a quick manual search and found the invoices are on both
sheets.

=VLOOKUP(E3,'[Metrossl billing.xls]Sheet1'!$A:$C,1,FALSE)

What can I do?

Thank you, Siobhan

Vlookup
 

maybe you want
,2 or ,3 instead

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Siobhan Plover" wrote in message
...
Help! I am comparing Invoices numbers on two large spreadsheets and have
this formula. The Problem I have is that it is not showing me the correct
results. I've done a quick manual search and found the invoices are on
both
sheets.

=VLOOKUP(E3,'[Metrossl billing.xls]Sheet1'!$A:$C,1,FALSE)

What can I do?

Thank you, Siobhan