| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup populated cell before an empty one??
A B C
1000 3500 200 My query is about excel picking up the right cell based on population. So IF C is populated use C, IF C is NOT populated and B is use B but if B is also not populated use A. I dont know if a function that uses the cell that is populated and furthest to the right will work IE: If A B & C were populated it would use C but if only A was populated it would use A?? Or if there is a function that picks up a number before a balnk cell?? -- Elsmith x |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup populated cell before an empty one??
Try,
=LOOKUP(2,1/(A1:Q1<""),A1:Q1) Mike "Elsmith" wrote: A B C 1000 3500 200 My query is about excel picking up the right cell based on population. So IF C is populated use C, IF C is NOT populated and B is use B but if B is also not populated use A. I dont know if a function that uses the cell that is populated and furthest to the right will work IE: If A B & C were populated it would use C but if only A was populated it would use A?? Or if there is a function that picks up a number before a balnk cell?? -- Elsmith x |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup populated cell before an empty one??
Thank you Mike, thats perfect!!
-- Elsmith x "Mike H" wrote: Try, =LOOKUP(2,1/(A1:Q1<""),A1:Q1) Mike "Elsmith" wrote: A B C 1000 3500 200 My query is about excel picking up the right cell based on population. So IF C is populated use C, IF C is NOT populated and B is use B but if B is also not populated use A. I dont know if a function that uses the cell that is populated and furthest to the right will work IE: If A B & C were populated it would use C but if only A was populated it would use A?? Or if there is a function that picks up a number before a balnk cell?? -- Elsmith x |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup populated cell before an empty one??
Your welcome
"Elsmith" wrote: Thank you Mike, thats perfect!! -- Elsmith x "Mike H" wrote: Try, =LOOKUP(2,1/(A1:Q1<""),A1:Q1) Mike "Elsmith" wrote: A B C 1000 3500 200 My query is about excel picking up the right cell based on population. So IF C is populated use C, IF C is NOT populated and B is use B but if B is also not populated use A. I dont know if a function that uses the cell that is populated and furthest to the right will work IE: If A B & C were populated it would use C but if only A was populated it would use A?? Or if there is a function that picks up a number before a balnk cell?? -- Elsmith x |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First populated cell in row array/ Last populated cell in row arra | Excel Worksheet Functions | |||
| LookUp to Display Last Value Populated a in Range | Excel Worksheet Functions | |||
| Lookup to Show Empty Cell | Excel Worksheet Functions | |||
| Return nothing if cell is populated | Excel Discussion (Misc queries) | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Linear Mode
