EXCEL 2003 RETURN VALUE BASED ON ANOTHER COLUMN

[newworld51]

Hello,

I have 2 columns with only vendor name and account #.

I have columns with multiple invoices and corresponding account #

How do I return the vendor name in the blank column based on the account #?

Inv #| Account # | Blank | Account # | Vendor Name
1 | A1 | ______ | A1 | ALPHA.
2 | A1 | ______ | B1 | BETA
3 | F1 | ______ | C1 | CHARLEY
4 | B1 | ______ | D1 | DELTA
5 | C1 | ______ | E1 | Epsilo
6 | A1 | ______ | F1 | Frank

Thanks for Any help!!!

 

[Lilliabeth]

Assuming the text Inv# is in cell A1:


=VLOOKUP(B2,$D$2:$E$7,2,FALSE)

 

[newworld51]

Great,
Thank You so much!!!!