Hi,
I hope someone could help me with this - I want to be able to copy some items from sheet 1 to sheet 2 without losing the values of a certain field. When I do a simple vlookup, the value of a certain field copies only one type. Please see attached file for more details.
Thank you in advance!
A2:
=IFERROR(INDEX(Sheet1!A$2:A$13,SMALL(IF(Sheet1!$G$2:$G$13="delivered",ROW(Sheet1!$G$2:$G$13)-ROW(Sheet1!$G$2)+1),ROWS(Sheet1!$A$2:A2))),"")
Confirm COntrol+shift+Enter
Drag down and accross
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks