Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding a number within a range
Hello,
We have a PO log that tracks the PO number series and the clinic they were issued to. I have a vlookup that appears to work most of the time but for some reason PO number 2244100 is showing 1888 instead of 1593. Maybe there is a better way of doing this?? Current Formula =VLOOKUP($Y:$Y,'[PO LOG.xls]All PO''s'!$A:$C,3) COLA_____COLB____COLC_ 2243651 2243700 5975 2243701 2243800 6197 2243801 2243900 1888 2443901 2244000 653 2244001 2244100 1593 2244101 2244200 2355 2244201 2244300 4359 2244301 2244400 2364 2244401 2244500 3036 2244501 2244600 357 2244601 2244700 456 2244701 2244800 542 2244801 2244900 545 Thank you! Cathy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FInding the largest number in a range meeting a criteria | Excel Discussion (Misc queries) | |||
Finding 2nd smallest number in range | Excel Worksheet Functions | |||
Finding the number of times a word is used in a range of cells | Excel Worksheet Functions | |||
Finding Minimum but if same number repeats in the range, then find | Excel Discussion (Misc queries) | |||
Finding number of values in a range on a per year basis | Excel Worksheet Functions |