| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup on two fields ....if here do this if not do that?
these are hard to explain with out examples..
i want run a lookup from two different columns. if there is a value in column A i want it to lookup the value for column B. but if the is no value in column A i want to lookup the value for Column A using the value in column B. i want to do this without the formula just looping round. Column A and B are linked in the the lookup spreadsheet. Hope this enough for someone to help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| Lookup based on two fields without merging? | Excel Worksheet Functions | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Threaded Mode
