| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to figure out IF formula
QHello all,
I have two sheets. Sheet1 contains about 4547 rows the sheet2 4645 rows. Sheet 1 contains parts that are in sheet two so I'm trying to put a formula that if Sheet 1 colum E equals Sheet 2 column M, then put sheets 2 Column Q data into Sheet 1 column K I have put following formula in Sheet 1 column K =IF(E:E='SHEET2'!M:M,'SHEET'!Q:Q,"no price") This doesn't work right becuase sheet 1 has less records. Is it possible to work around this? Please advise. Thanks for any help. J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't figure out the formula | Excel Discussion (Misc queries) | |||
| Can not figure out appropriate formula | Excel Discussion (Misc queries) | |||
| FORMULA TO FIGURE AGE | Excel Worksheet Functions | |||
| Can anyone figure a formula for this?? Please? | Excel Worksheet Functions | |||
| Cant figure out formula? | Excel Worksheet Functions | |||
Threaded Mode
