Hi,

I need help writing a formula with vlookup that will pull information from 2 different sources into the same cell to pull in different information. I'm going to try to explain what i'm trying to do and will be able to send the excel sheet if needed.

I have (2) guest log sheets with different guest information on them. I made a sign in sheet that can pull information from the one sheet and fill in the guest information exactly like I want using the vlookup formula by using guest numbers.

I have another sheet that is for a different guest list. I want my formula to be able to choose which list to pull the guest data from by guest number.

so if one list is 1,2,3,4,etc. and the other is a,b,c,d,etc

example:
if I put "1" in cell B2 and the result is MIKE

I would also like the option that if cell B2 is "a" the result would be Steve

Thank you,

Brian

Attached Files

TI_Res_info.xlsx (97.5 KB, 10 views)