Hello,
Based on an ID system, I used vlookup to get dollar amounts from four different worksheets because they're categorized. Now my main worksheet has the ID column and four columns representing each category. Since the first column represents the ID numbers, each ID row only has one correct value, while the other three values in each row are "#N/A".
Somehow, I would like to write a function that searches each ID row and only returns a value if it is not "#N/A".
Can somebody please help me?
Thank you,
Ract
Bookmarks