| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find value in column F, then display value in column A of that row
I'm trying to populate a new worksheet by flagging cells in a previous
worksheet. Specifically, populate the first column of worksheet named BestBall using this logic: If Entry!F4:F154 = "bb1", then grab value of column A and display in first column of BestBall. So, let's say we find "bb1" at Entry!F30 and F59. The values contained in Entry!A30 and A59 need to display in BestBallA4. Thank you, rc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a string within a column | Excel Discussion (Misc queries) | |||
| How do I find the largest in a column | Excel Worksheet Functions | |||
| Find a time value in one column based on names in another | Excel Discussion (Misc queries) | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Threaded Mode
