Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Help please to match data in a range, get the next column's value.
Hi everyone,
I'm preparing some sort of a price list and I'm trying to find a way to match a cell's value within a range and get the next column's value. Let's say I have the value 4550 in A4 value of worksheet 1, and a range of numbers with prices next to them in an other worksheet. What I need should sound like this: IF THE VALUE OF A4 (of SHEET1) EXISTS IN RANGE A1..A1000 (of SHEET2) THEN B4 (of SHEET1) = B??? (of SHEET2) WHERE ??? IS THE ROW NUMBER WHERE THE VALUE OF A4 IS MATCHED I hope I didn't sound out of my mind :) Thanks for any help. All best! |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Help please to match data in a range, get the next column's value.
Look in HELP how VLOOKUP() works
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Alper" wrote in message om... Hi everyone, I'm preparing some sort of a price list and I'm trying to find a way to match a cell's value within a range and get the next column's value. Let's say I have the value 4550 in A4 value of worksheet 1, and a range of numbers with prices next to them in an other worksheet. What I need should sound like this: IF THE VALUE OF A4 (of SHEET1) EXISTS IN RANGE A1..A1000 (of SHEET2) THEN B4 (of SHEET1) = B??? (of SHEET2) WHERE ??? IS THE ROW NUMBER WHERE THE VALUE OF A4 IS MATCHED I hope I didn't sound out of my mind :) Thanks for any help. All best! |
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Help please to match data in a range, get the next column's value.
Alper,
Not tested, but this is the sort of thing that you want =IF(ISERROR(MATCH(A4,Sheet2!A1:A1000,0)),"",VLOOKU P(A1,Sheet2!A1:B1000,2,FAL SE)) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alper" wrote in message om... Hi everyone, I'm preparing some sort of a price list and I'm trying to find a way to match a cell's value within a range and get the next column's value. Let's say I have the value 4550 in A4 value of worksheet 1, and a range of numbers with prices next to them in an other worksheet. What I need should sound like this: IF THE VALUE OF A4 (of SHEET1) EXISTS IN RANGE A1..A1000 (of SHEET2) THEN B4 (of SHEET1) = B??? (of SHEET2) WHERE ??? IS THE ROW NUMBER WHERE THE VALUE OF A4 IS MATCHED I hope I didn't sound out of my mind :) Thanks for any help. All best! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a report sheet based on 1 column's data | Excel Worksheet Functions | |||
AVERAGE a range in a column if another column's range equals a val | Excel Discussion (Misc queries) | |||
How to specify 2nd column data depending on 1st column's data? | Excel Discussion (Misc queries) | |||
How do I get the current column's data from that cell to another? | Excel Worksheet Functions | |||
How do I collate (match-up) one column's data with another? | Excel Worksheet Functions |