sheet1.xlsxsheet2.xlsxHello all,
I'm very amateur in the world of Excel formulas. I have been attempting to find the right way to find certain cells. I'm unsure if I should be using match or hlookup. Please see my scenario below though:
2 excel sheets
Sheet 1: Has information only on 2 rows and 2 rows only
Sheet 2: I need to format info from Sheet 1 into a specific format
Bananas 1 2 3 4 5 6 Apples 1 2 3 4 5 6 Oranges 1 2 3 4 5 6 Pears 1 2 3 4 5 6 normal split smushed blended fried cut normal split smushed blended cut normal blended cut normal split smushed blended cut
1 2 3 4 5 6 Bananas Apples Oranges Pears
My issue is that the formatting completely changes from sheet 1 to sheet 2. I have tried the following formula on sheet 2: =hlookup(a2,'[sheet1'!$A$1:$AB$2,2,FALSE)
This gives me the cell right under Bananas, when in truth I need to find the cell over to the right of it to show me "normal" in the 2nd row. Is there any way for me to choose the 2nd row but the cell over to right instead? Or if I needed to find the cell 2 over? I do apologize if this is confusing as I'm unsure of how to show the issue appropriately.
I have attached my sheets for examples if that helps.
Bookmarks