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)

Hi Brian,

So many things are possible, but without a test sample workbook, we might merely be guessing.

how can I attach my worksheet or send it to you?

I have attached a copy to my original post. I somehow missed where to attach the file.

Thanks for the attachment. Can you now give me a clearer understanding of what you want to achieve?

What I want to do is has the option to fill out the log sheet with either information from the call-in log or the PGL log. So what needs to happen is we have a permanent guest list here and also a list for call in list which is different daily. I want to be able to just use an ID number to have the information populate on the guest log sheet. From the 2 different data sheets.

The data sheets need to be separate as there are a lot of names to add to it and the other changes daily as I mentioned. I'm open to use any formula to achieve this as I've watched several videos and they all have a different way of doing things.

the formula needs to be made so that it can read an entire column on both sheets as the number of entries can vary

Since it appears in column B the difference is text versus a number (1, 2, 3, etc.), then this should do it...

Paste into C2 and copy across and down
=IFERROR(VLOOKUP($B2,IF(N($B2),'CALL-IN LOG'!$A:$E,PGLLIST),COLUMN(B$1),FALSE),"")

Thank you for the advice. I won't be able to try the formula until tomorrow as I'm away from my computer and at work right now. I will let you know the results when I am able to apply them.

Thanks again

Brian

@bdcrawford
Hello
please don't quote entire posts unnecessarily. Quotes are just clutter and make the thread hard to follow. Thank you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

@jefferybrown

It worked great

Thank you

Good news and you are very welcome.