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! |
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 |