Greetings,
Attached is a spreadsheet which compares servers in column A with servers in column E. Any servers which are listed in column A but not listed in column E are subsequently listed in column F.
The problem I need help with is this:
I need to have the associated server info in columns B,C, and D correspond with any servers which are listed in column F. I have left room for this data in columns G, H, and I but I don't know how to adjust the helper code.
Can anyone help?
Thanks,
Ken
so, results I am seeking look like this:
test pic.jpg
Enter this in G2 with Ctrl + Shift + Enter and copy across and down
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you for the reply. The results do not match up as expected. Please see the attached screen shots
actual results: test pic2.jpg
desired results: test pic.jpg
Here is your file with minor modification to the formula to accommodate the blank cells that you want.
worked perfectly, thanks!!
You're welcome.
Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks