find contents of ajoining cell


  1. Posts : 166
    microsoft windows 10
       #1

    find contents of ajoining cell


    Hi all,,, I have a single column array and using vlookup to get a cell, and I need to know what the cell above it contains. Can you help please.
    Len
      My Computer

  2. cereberus's Avatar
    Posts : 12,018
    Windows10
       #2

    Easiest way is to copy the single column next to it but one row down

    e.g.

    Code:
    A
    BA
    CB
    DC
     D
    Vlookup has to cover range of both columns, then use colum index as 2.
      My Computer


  3. Posts : 166
    microsoft windows 10
    Thread Starter
       #3

    Thanks very much,,,that works for me.
    Len
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 14:53.
Find Us




Windows 10 Forums