| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search without sort in the sheet
Is there a way that I can search for a string without using lookup, I don't
want t o sort any columns or rows. This is what I would like to do: Search for if (Sheet1!b2= a2) and (sheet1!c2=b2) then place the string from Sheet1$c2 in the current cell This will be copied down to 100 cells in the current sheet. I tried sumproduct, but it didn't work. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| Sort/Search Arrays | Excel Programming | |||
| How Do I Sort search results? | Excel Programming | |||
| How can I sort or search the sheet tabs? | Excel Worksheet Functions | |||
Threaded Mode
