excel vba vlookup function

Lambel
Lambel used Ask the Experts™
on
I am trying to pull a value from anothre sheet for the same customer number on the first sheet. I can't get my vlookup to work (sheet "OH Count", cell D2).  Can someone tell me why this won't work - or better yet, fix it for me?

Book4.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Just change your formula to this:

=VLOOKUP(A2,'OH Pool'!A$2:C$1000,3,FALSE)

and copy down.

jppinto
Commented:
If you want to avoid showing #N/A when there is no match, you can change your formula to this:

=IF(ISNA(VLOOKUP(A2,'OH Pool'!A$2:C$1000,3,FALSE)),"",VLOOKUP(A2,'OH Pool'!A$2:C$1000,3,FALSE))

jppinto

Author

Commented:
Perfect!  Thanks much!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial