formula to match cell on current worksheet to a cell in an array on a different worksheet, and then display value of cell in same row of array

[Jmoz092]

Hello, I am stumped on how to pull a cell value from a row on a separate worksheet.

I have a workbook that begins with two spreadsheets, "2024" and "Worksheet (master)". Going forward, I will copy/paste Worksheet (master) onto the 3rd, and subsequent, worksheets. On the Worksheet (master) worksheet and subsequent worksheets, I need formulas that will reference the active worksheet's cell i4 to find that number on spreadsheet 2024, then display values from different cells in that row into varying cells (b4, f4, v9, etc) on the active worksheet, and then onto subsequent worksheets so that each newly created spreadsheet displays cell values from unique i4 values from spreadsheet "2024".

 

[dreid1011]

Sounds like a lookup may help, but your image does not look complete. Can you post a sample of your sheets with the XL2BB addin, and update your profile with your Excel version.

 

[Jmoz092]

Tried a Vlookup, but couldn't get that to work either. Tried accounting for numbers as text and all that also. I can post back a sample this evening, thank you.