@ajmal pottekattil yoousuf
In Excel, you can use the VLOOKUP or INDEX/MATCH functions to look up a value in a table with different range values.
Here’s an example of how you can use the VLOOKUP function to look up a value in a table:
Let’s say you have a table of data in cells A1:C6, where column A contains the range values, column B contains the item names, and column C contains the prices. You want to look up the price of an item based on its name.
You can use the following formula to look up the price of the item named “Item B” in the table:
=VLOOKUP("Item B", A1:C6, 3, FALSE)
This formula uses the VLOOKUP function to search for the value “Item B” in the first column of the table (column A) and returns the corresponding value from the third column of the table (column C), which contains the prices. The fourth argument of the VLOOKUP function is set to FALSE to specify that an exact match should be found.
Alternatively, you can use the INDEX and MATCH functions together to achieve the same result. Here’s an example of how you can use these functions to look up the price of “Item B” in the same table:
=INDEX(C1:C6, MATCH("Item B", B1:B6, 0))
This formula uses the MATCH function to search for the value “Item B” in column B of the table and returns its relative position. The INDEX function then uses this position to return the corresponding value from column C of the table, which contains the prices.
I hope this helps!
