How do I lookup a value in say column and in returning the found
Closed
Sheengle
-
Sep 14, 2015 at 12:58 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 14, 2015 at 01:11 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 14, 2015 at 01:11 PM
Related:
- How do I lookup a value in say column and in returning the found
- Display two columns in data validation list but return only one - Guide
- Https //accounts.google.com/sign in/v1/lookup - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
- Area code lookup - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 14, 2015 at 01:11 PM
Sep 14, 2015 at 01:11 PM
Sheengle, Good afternoon.
Following your example:
....a.....b.......C
--------------------
1 q.....r......=formula
2 f......f......
3 e.....h.....
4 q.....w.....
5 r.....m.....
C1 --> =IF(A1="Q","NEW","")
Is that what you're looking for?
I hope it helps.
Following your example:
....a.....b.......C
--------------------
1 q.....r......=formula
2 f......f......
3 e.....h.....
4 q.....w.....
5 r.....m.....
C1 --> =IF(A1="Q","NEW","")
Is that what you're looking for?
I hope it helps.