| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Find or Lookup?
I am trying to look to see if a part number is in another worksheet and if so return Yes. How do I do this? I have tried several functions but they all return name so I am not even sure if I am doing this correctly.
|
|
#2
|
|||
|
|||
|
Quote:
=IF(COUNTIF(range,value)0,"Yes","") Swap 'range' for the workbook/sheet/cell range (easiest to do by selecting it with the mouse rather than typing it. Swap value for the part number or the relevant cell reference if the part number is stored. Hopefully that will do the trick. Let me know if not. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find max with a lookup | Excel Discussion (Misc queries) | |||
| Lookup / find value in column which changes | Excel Worksheet Functions | |||
| Lookup...find next | Excel Discussion (Misc queries) | |||
| Can't find the min of a lookup reference | Excel Worksheet Functions | |||
| Find, Lookup, who knows??? | Excel Programming | |||
Hybrid Mode
