using the MATCH function to get a row index and thus retrieve the cell contents in the row

[H28Sailor]

Hi

I am using MATCH(A2, worksheet!H;H, 0) to retrieve the row index from the 'worksheet' using the value in A2 and seeking the first occurance

All good, so far

but.....I am unclear how to retrieve the contents of another cell in that very row in 'worksheet'

Bob M

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

You need to include a 2nd MATCH, and put them both inside INDEX. Something like this...

=INDEX(worksheet!A;H,MATCH(A2, worksheet!H;H, 0),match(B2,worksheet!1:1,0))
where...
A;H is the full range you are working with
B2 = the column you need to find
worksheet!1:1 is the row, on WH where the headings are.

Adjust the ranges as needed

when all else fails, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.