Hi again Patricia,

VLOOKUP(B3,Pending_Sites!A2:E118,1,FALSE)

This is what your 1st VLOOKUP section.
1. "B3" is what you will match
2. "Pending_Sites!A2:E118" is what your range where B3 will search for
its match
3. "1" is the column number from where you will get your result
4. It may be "TRUE" or "FALSE"

Your mistake
The range must start from the column you are VLOOKUP so it will be
"Pending_Sites!B3:E118" and not "Pending_Sites!A2:E118". Which means B3
must be the leftest column. So, B3 will be your 1st column, C3 will be
2nd and so on.

This is for the normal case. Where the LOOKUP works in right hand
direction. And it is a simple process.

Try to correct the function and if possible rearrange the table.



Thanks

Shail


Patricia wrote:
Shail,

The column number is correct. The first column in the other spreadsheets is
Store number which is where the vlookup should check.
Columns a (1) Store number, (2) Address, (3) City, (4) State, (5) Zip
Code or similar but the Store number is always first so I can do other
lookups for sales, etc.

Patricia