|
Lookup row and columbn using text for both
I'm not sure if this is possible, but I supposed everything is with Excel.
I want to create a lookup formula using text for the row and column. I know i can use a vlookup or hlookup and use text as the first parameter, but you are required to put in a # for the column or row depending on the formula. Is there anyway I can lookup text on both the column and row to pull data. a b c 1 abc 2 xyz 50 3 What I want to do is, =VLOOKUP("xyz",A1:C3,"abc",FALSE) and it would return the 50. I use many sheets that will always have the same text, but the columns or rows may change and I don't want to have to spend more time making sure the formula is correct than the data is correct. Ken |
Lookup row and columbn using text for both
|
Lookup row and columbn using text for both
The general syntax would be:
=VLOOKUP("xyz",A1:C3,MATCH("abc",A1:C1,0),0) Better to use cells to hold the criteria: E1 = xyz F1 = abc =VLOOKUP(E1,A1:C3,MATCH(F1,A1:C1,0),0) -- Biff Microsoft Excel MVP "kensmith" wrote in message ... I'm not sure if this is possible, but I supposed everything is with Excel. I want to create a lookup formula using text for the row and column. I know i can use a vlookup or hlookup and use text as the first parameter, but you are required to put in a # for the column or row depending on the formula. Is there anyway I can lookup text on both the column and row to pull data. a b c 1 abc 2 xyz 50 3 What I want to do is, =VLOOKUP("xyz",A1:C3,"abc",FALSE) and it would return the 50. I use many sheets that will always have the same text, but the columns or rows may change and I don't want to have to spend more time making sure the formula is correct than the data is correct. Ken |
Lookup row and columbn using text for both
That is freakin fantastic, thanks for the help Biff.
"T. Valko" wrote: The general syntax would be: =VLOOKUP("xyz",A1:C3,MATCH("abc",A1:C1,0),0) Better to use cells to hold the criteria: E1 = xyz F1 = abc =VLOOKUP(E1,A1:C3,MATCH(F1,A1:C1,0),0) -- Biff Microsoft Excel MVP "kensmith" wrote in message ... I'm not sure if this is possible, but I supposed everything is with Excel. I want to create a lookup formula using text for the row and column. I know i can use a vlookup or hlookup and use text as the first parameter, but you are required to put in a # for the column or row depending on the formula. Is there anyway I can lookup text on both the column and row to pull data. a b c 1 abc 2 xyz 50 3 What I want to do is, =VLOOKUP("xyz",A1:C3,"abc",FALSE) and it would return the 50. I use many sheets that will always have the same text, but the columns or rows may change and I don't want to have to spend more time making sure the formula is correct than the data is correct. Ken |
Lookup row and columbn using text for both
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "kensmith" wrote in message ... That is freakin fantastic, thanks for the help Biff. "T. Valko" wrote: The general syntax would be: =VLOOKUP("xyz",A1:C3,MATCH("abc",A1:C1,0),0) Better to use cells to hold the criteria: E1 = xyz F1 = abc =VLOOKUP(E1,A1:C3,MATCH(F1,A1:C1,0),0) -- Biff Microsoft Excel MVP "kensmith" wrote in message ... I'm not sure if this is possible, but I supposed everything is with Excel. I want to create a lookup formula using text for the row and column. I know i can use a vlookup or hlookup and use text as the first parameter, but you are required to put in a # for the column or row depending on the formula. Is there anyway I can lookup text on both the column and row to pull data. a b c 1 abc 2 xyz 50 3 What I want to do is, =VLOOKUP("xyz",A1:C3,"abc",FALSE) and it would return the 50. I use many sheets that will always have the same text, but the columns or rows may change and I don't want to have to spend more time making sure the formula is correct than the data is correct. Ken |
| All times are GMT +1. The time now is 04:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com