Vlookup or something else?

[cschoyer]

I need help! I have a spreadsheet in which I enter vendor information and who of our employees approves the invoices for each particular vendor. Is there a formula I can use that will automatically enter which employee approves the invoice when I enter the vendor in the spreadsheet?

I have attached an example.
I want to have my spreadsheet automatically enter Chris in column C under Approved by when I enter either Xxyy or PPll in the vendor columnBook2.xlsx

[bonny24tycoon]

Hi cschoyer,

Where would we get the source information from. Is it a different workbook?


Thanks,

Bonny Tycoon




**If I was able to help please click the small star icon at the bottom left of my post **

[cschoyer]

the source information is in the same workbook, on a different worksheet

[dilipandey]

Hi cschoyer,

You can use the vlookup function here but for that you need to define the table criteria, see the attached file.
=VLOOKUP(B2,$J:$K,2,0)

Sample;
Book2(6).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[Ishtiyaq]

Hi,

You can use vlookup formula to fix this issue. The formula you can use is =IF(ISNA(VLOOKUP($F2,$B$2:$C$8,2,0))," ",VLOOKUP($F2,$B$2:$C$8,2,0)).

I've added ISNA to avoid NA erorr for blank cells. Please check the attached excel sheet.

Hope this helps.

Warm regards
Ishtiyaq

[bonny24tycoon]

Check out the this... Book2.xlsx Assuming the source file in Sheet2.



Thanks,

Bonny Tycoon




**If I was able to help please click the small star icon at the bottom left of my post **

[icestationzbra]

another approach...