Pulling Specific Data From Columns Linked To Specific Text/Number

[hhouck]

Hi there,

I'd like to type in a number on my spreadsheet and have the information in that number's column auto populate specific cells.

For example, I am a recruiter and each requisition I work has a unique number. I'd like to have the ability to type R1234 and have the information from a list of requisitions auto populate for me on a separate sheet. I hope I'm explaining this correctly, I'm new to Excel. I thought maybe VLOOKUP would work but have no clue how to execute.

Any help would be greatly appreciated!!!

 

[Z51]

For C9 ("Seat(s)") you could use:

=INDEX('Requisitions Tracker'!A:A,MATCH(C$6,'Requisitions Tracker'!B:B,0))

Use the same formula in C10:C13, just change the A:A to D:D, E:E, F:F and G:G.

 

[hhouck]

For C9 ("Seat(s)") you could use:

=INDEX('Requisitions Tracker'!A:A,MATCH(C$6,'Requisitions Tracker'!B:B,0))

Use the same formula in C10:C13, just change the A:A to D:D, E:E, F:F and G:G.

I'm really starting to love excel, thank you very much for your help. You are my hero today!