Lookup function

[Sandi Rush]

Hi all:

Bit of a novice here on formula structure & this may be
out there already, but running very short on time. I hate
to just post & run, but here it is.....

Sheet 1 is a log of transactions
Column A - Dealer Code
Column B - Dealer Name
C-G - Various other info pertaining to transaction

Sheet 2 named as Independents is a Dealer Listing
Column A - Dealer Code
Column B - Dealer Name
Column C-G - Various other dealer info

Wanting Sheet 1 B2 to be auto-filled based on my entry in
Sheet 1 A2, I have the following:

=LOOKUP(A2,Independents!A1:A159,Independents!B1:B159)

Result showing data one row up in Dealer listing from
actual match. Any thoughts?

All help is sincerely appreciated!

Sandi

 

[Frank Kabel]

Hi
try:
=VLOOKUP(A2,Independents!$A$1:$B$159,0)

 

[Sandi Rush]

Receiving error message..... Is something missing from
your reply?

Thanks!
Sandi

 

[Dave Peterson]

=VLOOKUP(A2,Independents!$A$1:$B$159,2,0)

This will return the 2nd column (of A1:B159 on independents) if there's an exact
match with A2.

If there's no match, you'll get #n/a

If you want to hide that error:

=if(iserror(vlookup(...)),"Missing",vlookup(...))

 

[Frank Kabel]

Hi Dave
thanks for the typo correction ))

 

[Sandi Rush]

A world of thanks to you both..... I had tried the
vlookup function on my own, but was not getting the "0"
portion correct.

Have a great day!
Sandi