IFERROR with VLOOKUP
A Rose
✭✭✭✭✭
HI there,
I have 2 columns of old data and updated data, e.g. "Name1" & "Name1 Updated"
Can i do a vlookup, and iferror keep old data?
Thank you!
Answers
-
Should be able to, yes.
=IFERROR(VLOOKUP(Cell, New Range, Return Value Column Number, True/False),VLOOKUP(Cell, Old Range, Return Value Column Number, True/False))
-
-
-
@A Rose , how can I put this differently cuz I can't make it make sense myself. HA
When you highlight the range you are referencing on a sheet, with the column that your searching in being Column Number 1 (Doesn't matter where it lands), counting to the right, what Column Number is the column you would like your result to be pulling from? That is what I mean by "Return Value Column Number"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!